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