UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3O4ldhDppP5yH/fdVpLDVLDrCaY5BSYpE0jgrtiUmW4='
WHERE
key_id = '8329a7adcc607a0de15fc0d4bb645c69486169652ce35f028f32033bc99cf68d'
AND (
token = '3O4ldhDppP5yH/fdVpLDVLDrCaY5BSYpE0jgrtiUmW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)