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