SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '45ddd831c44c352a54dc18e0fd7a2a56f420990f2dd559f73b5e6b99b4c2ab5d' 
  AND token = '/koSEK3NB4aLF4ePXbqxYKtRcTD2Nc/KnmJVV6cFmmg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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