UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9krazkRUDL5nTbdu+ubZ2u8Rk7WOGExyvGvSM42d6kU='
WHERE
key_id = '5fccc48bacb901e81c220039480447b2d621f507ca6947923ad75586409112f3'
AND (
token = '9krazkRUDL5nTbdu+ubZ2u8Rk7WOGExyvGvSM42d6kU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)