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