UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgr7Dtk6UkaOj23GClAYyOMJibX3OAbN+9TQvnTkPwU='
WHERE
key_id = 'e482d54c403ddad585ceaa1388300b83633fb0b24e9093e9e32a5c2bf31ccf3b'
AND (
token = 'qgr7Dtk6UkaOj23GClAYyOMJibX3OAbN+9TQvnTkPwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)