SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b92e63c4c48ec7fd0d3d947cda98603bb1689be9e54d4d7d5ad996201e205af7' 
  AND token = 'L6Z/6f4d2CaXIqUaHzrZvCkXKZaJ57HlL3jZu4A4pnw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}