UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47gPD/fLmPV7X7DqdqJpcZ6UDTSIXHW01x+zeN22/Tk='
WHERE
key_id = '0255bec5511bf8daaca067cb801a35c30e1f4dfd52490b71c6f0e73907abae6f'
AND (
token = '47gPD/fLmPV7X7DqdqJpcZ6UDTSIXHW01x+zeN22/Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)