UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHqNmMCczwNGUujlM0hQzmuk6sqm+1WwG4yTIPThV/w='
WHERE
key_id = 'fd5d016c35bf740a9c9acaf2ccb01e0f61288887956141ed051302fbc997fb5c'
AND (
token = 'BHqNmMCczwNGUujlM0hQzmuk6sqm+1WwG4yTIPThV/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)