UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8N6xTYd27dKFcfev9sLkJnTgL7HnM20/Pf0ZqW2I+JE='
WHERE
key_id = '7ff4b786df5655c83a82281199d085db1b9b59f6366a5e8f9c976299f86410c7'
AND (
token = '8N6xTYd27dKFcfev9sLkJnTgL7HnM20/Pf0ZqW2I+JE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)