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