UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXpzlWLufMB2HNco081CY9x+bMnrNPbHC/IF0y19CiU='
WHERE
key_id = 'e91d7f073e450f2cb768f50b15622836175aa0a7eb7edcf006edb316a0739231'
AND (
token = 'zXpzlWLufMB2HNco081CY9x+bMnrNPbHC/IF0y19CiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)