UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4REyetmECqB3rxS896njECkmVR2WOi48KmxUTGBVwm8='
WHERE
key_id = 'c4923027a7136936f587c3f17707a65593af2b7aff98f13268daa3bfb4ef4798'
AND (
token = '4REyetmECqB3rxS896njECkmVR2WOi48KmxUTGBVwm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)