UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hkccJwUU87Qn7YbUFOdnqR/06ynG5WK7SFQUXG4pY8='
WHERE
key_id = '87b86a7d8e9dce3473b72c0d1d52872eb98635fd5e5ceb4ead96814ed281804f'
AND (
token = '1hkccJwUU87Qn7YbUFOdnqR/06ynG5WK7SFQUXG4pY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)