SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '298154603083900cdd3cd1d9eab1df325e311c3ed18482b0803b064ebd70afcf' 
  AND token = '8nBlJfdygiR0deL2I6PUn4c/t1q5qa6MV2qfZzRrVPQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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