UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XX1l4PYW/3lrnL8fslTMe0EAqTVdVwdyS/EJtkoywOE='
WHERE
key_id = '9362d8e74508f185f9a7b53e6b90dd673c03c8dc2c94b7c5f3b3485332707244'
AND (
token = 'XX1l4PYW/3lrnL8fslTMe0EAqTVdVwdyS/EJtkoywOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)