SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2b38f783c76b18d698b74ca2c6a694527fc063f76caa9c5d68aaf83d1c4f1269' 
  AND token = 'QCKivtUY9Qs1wYL4mlwj5ZNCaE0R/kZtm62/+d5XAdI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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