UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QqxGpyANfHTH6kM4RvtwYrphMKELfPXE0wARDjnfNYw='
WHERE
key_id = '7646fda42b7854994d83b4886293cf8044c18947ebb3413b7b62beb7bc402328'
AND (
token = 'QqxGpyANfHTH6kM4RvtwYrphMKELfPXE0wARDjnfNYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)