UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cn28AR2C4KCy+ewksRY+reB8KW/Hame3apD8M+iKUgU='
WHERE
key_id = '513dbe29b4cdd11f238729178c12b50e0d6a16912b669922efce981ad8ebe770'
AND (
token = 'cn28AR2C4KCy+ewksRY+reB8KW/Hame3apD8M+iKUgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)