UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1OU4q/1r7aAv048ju9+DdhpBvS84591ruF+rA4oz+uY=' 
WHERE 
  key_id = '4fa970dd51073266160268e11aa6fe0dcbca2733d9c10fd7b7c37fcc367c1fd0' 
  AND (
    token = '1OU4q/1r7aAv048ju9+DdhpBvS84591ruF+rA4oz+uY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038