UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mPApgWMDlR8PVojTkzaAqM+oismT1md0OLTW06zSEN4=' 
WHERE 
  key_id = '3216e0fd5857aa3eaa5ce64c25767cd98e6a2e5a894d9e1c0f9612b0ad1c6058' 
  AND (
    token = 'mPApgWMDlR8PVojTkzaAqM+oismT1md0OLTW06zSEN4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032