SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bc9346b98c1b633a586eb96b4e8783195a3ce08aee664b0ae14c95714ec03bfe' 
  AND token = 'M0k/u6M/EcQA1rKPIk/TXNEWn4mEVwiTuPZVI8NRKqM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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