UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qq7M+Ytbs1AkoNN/IbSC3snBvXqfyUlcBfJTiYOi9y0='
WHERE
key_id = 'f6885f708eae1c7ce58fd230569930d30b1864307f9c672ef099b3a8a16c9d3a'
AND (
token = 'Qq7M+Ytbs1AkoNN/IbSC3snBvXqfyUlcBfJTiYOi9y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)