SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7bda8b805780070c57ccea5e2ad91fa6627cce2b223db9d3d67b73f47d19ee90' 
  AND token = 'Kv2CYTqSko3RaAYK5Ha5h28hspJ0mvLl/I1VSUOtl64=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00054

JSON explain

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