UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R17lG4vKVa2ZdAAKHQAHhIW+rQ8v3YZkVuacRurntFo='
WHERE
key_id = 'be38eefba1262b39bc9140121741fff432b3dc4a82e6215e8bbb7e9f57edeb1f'
AND (
token = 'R17lG4vKVa2ZdAAKHQAHhIW+rQ8v3YZkVuacRurntFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)