SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b3b0ec8d2f05427f2c670055c42b88654dd4511825b2325d375cd746d7e0f34b' 
  AND token = 'f7QKmXR5dCPeYR4AaHAOJRS9d0K9ASaBGy9CsamsHFc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}