UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2NInnq44LdZk0lCd6gYdszgRPITA6jEO9tzVlwEcMc='
WHERE
key_id = 'bdc791b574baa65097761ec37f8cd089993dc8d2090bb135e1f55b8aaf28e24b'
AND (
token = 'C2NInnq44LdZk0lCd6gYdszgRPITA6jEO9tzVlwEcMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)