UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fCrLkp5MJTcYsOO1EtpOnrHmYBYf7Aq4cigURtm1iF4='
WHERE
key_id = 'ea87b9f11bb3d64bd2d85b66a0bd0c96bbd9d978ea739a667486212df86fa114'
AND (
token = 'fCrLkp5MJTcYsOO1EtpOnrHmYBYf7Aq4cigURtm1iF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)