UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FoTie8qDk0E44c0Ooddz6L8mpJXGuNIJ+0vCUCMWV5k='
WHERE
key_id = '4ee51c7f303ca64c8d20a4aa84498f17b7d35c4a3a503e2dfa53c19abd3c9e8e'
AND (
token = 'FoTie8qDk0E44c0Ooddz6L8mpJXGuNIJ+0vCUCMWV5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)