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