UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/jwdmyxifiISxhYWZx9zMB7VzppgaImYy9o8IkSjEUU='
WHERE
key_id = '1ad77b19ee73d49e6cfda7f20da578b80f63d416865a7d0e6719abe7948ba232'
AND (
token = '/jwdmyxifiISxhYWZx9zMB7VzppgaImYy9o8IkSjEUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)