SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '717d064e606b56bf981f01f6b56713800a80f5a223a2a4f742ad5c2f19b2019c' 
  AND token = 'gOdymluyyBeSmP8rddy33SLp39TfBm+ue23TW2OA81E=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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