UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OfooD8ULu6+TOg2mRC+xKsxFYom8NHLji+mS7s6yJHs='
WHERE
key_id = '088c80592815756be4ba8b0c6988f0fcdbe8d8c17086971624d0b48e492a4f8d'
AND (
token = 'OfooD8ULu6+TOg2mRC+xKsxFYom8NHLji+mS7s6yJHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)