UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zc1WZZOyMjkxdVr4po6qtFFBQEiwpaU9Jr7h707t6iY='
WHERE
key_id = '77a855428c64f176f20cff09a622e8d58a51129fff0e87bdb986040b16b49f37'
AND (
token = 'Zc1WZZOyMjkxdVr4po6qtFFBQEiwpaU9Jr7h707t6iY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)