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