UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lBV0uxYlYCgZ8LhH60FyPhLh6g3sItzuAvSwrbKzeDA='
WHERE
key_id = '75d871b71a947c3e8ea98da51ebf8bc94a706ef4a80d78ff48539933b9d7f27c'
AND (
token = 'lBV0uxYlYCgZ8LhH60FyPhLh6g3sItzuAvSwrbKzeDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)