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

Query time 0.00024