UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cApLPJPWo7O8fAAdXNGjpcAIYw899/SuYKUgsxJlOs='
WHERE
key_id = 'db502efedaf147c379ad2ee60c9071cd8667e5eef3462b3ac3fa18f1540b724c'
AND (
token = '0cApLPJPWo7O8fAAdXNGjpcAIYw899/SuYKUgsxJlOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)