UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6+ZCJif3/PsKVUSLdWwo6sfrTubfLTwwbboJs+yOVk='
WHERE
key_id = '145fb46fbe3011489bdd08ef67a6f9adf8d10f518775a21fcb127de4e030b687'
AND (
token = '+6+ZCJif3/PsKVUSLdWwo6sfrTubfLTwwbboJs+yOVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)