UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xsAMcCtZXg9o4y/EEZrEZ9TS7f6lyDTKrhrIVS6ijI='
WHERE
key_id = '70c6c3a643912268cc61d068e150020ef8a30b910c8c2e532bab3d572c82f898'
AND (
token = '4xsAMcCtZXg9o4y/EEZrEZ9TS7f6lyDTKrhrIVS6ijI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)