SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8fb9ce52f105d06ff2dc2a26a6c35b91a1be0f25a60d3f2df761b4e4a6086563' 
  AND token = '0v20WAmUCEQZsqMX8FwsPgH3KZRtLPViUsyWweIwwcM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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